package com.wy;


import com.wy.campus.Room;
import com.wy.util.RecommendUtils;
import com.wy.vo.DueItem;
import com.wy.vo.LoanItem;
import com.wy.vo.OverDueLoanItem;
import com.wy.vo.PersonalLoan;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;


/**
 * Created by wy on 2017/11/2.
 */
public class Main {
    public static void main(String[] args) {

        System.out.println();
        StringBuffer sb = new StringBuffer();
        sb.append("SELECT gz.month,xm.xmmc,gz.je");
        sb.append(" FROM t_gzxm xm INNER JOIN t_gz gz ON xm.xmid");
        sb.append(" WHERE xm.xmid = gz.xmid");
        sb.append(" AND xm.schoolid = ?");
        sb.append(" AND xm.is_statistics_type = 1");
        sb.append(" AND gz.jgh = ?");
        sb.append(" ORDER BY gz.month,gz.xmid");
        System.out.println(sb);
    }
}
